

import openpyxl
from openpyxl import Workbook
# def getHtmlText(url):
#     try:
#         #pxs = {'http:': '172.25.0.36:8080','https:': '172.25.0.36:8080'}
#         #r=requests.get(url,timeout=30,proxies=pxs)
#         kv={'user-agent':'Mozilla/5.0'}
#         r = requests.get(url, timeout=30,headers=kv)
#         r.raise_for_status()#如果状态不是200,引发httpError异常
#         r.encoding=r.apparent_encoding
#
#         return r.request.headers
#     except:
#         return "产生异常"
# #if__name__=="__main__":
# url_OA="http://10.0.90.103:8080/noa/login"
# url_Baidu="http://baidu.com"
# print('\n',getHtmlText(url_OA))

wb = openpyxl.load_workbook("D:\SPLIL0009.xlsx")
print(wb.sheetnames)    # ['Sheet1', 'Sheet2', 'Sheet3']

